{"text_format":"2","workbook":"xlsx","n_sheets":6,"sheets":["1. Impact of cold stress","2. Energy required to grow","3. Basic Calculator","4. Instructions","5. Cost Calculator","Sheet 5"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"1. Impact of cold stress","index":0,"n_rows":19,"n_cols":9,"rows_kept":19,"cut":false,"hidden":false,"merged":[[1,1,1,5],[6,0,13,0],[4,2,4,8]]}
[]
[null,"Impact of Cold Stress on Energy Requirements"]
[]
[]
[null,null,"Extra energy required per day for specific temperature (MJ/day)"]
["Bodyweight (kg)",null,40,50,60,70,80,90,100]
["Ambient Temperature (assumed no drafts and a normal relative humidity) (◦C)",20,0,0,0,0,0,0,0]
[null,15,0,0,0,0,0,0,0]
[null,10,{"$f":"(((2.15*(C6^0.75))/0.8)*(5*4.184))/1000","v":0.89424217096211012},{"$f":"(((2.15*(D6^0.75))/0.8)*(5*4.184))/1000","v":1.0571525370052486},0,0,0,0,0]
[null,5,{"$f":"(((2.15*($C$6^0.75))/0.8)*(10*4.184))/1000","v":1.7884843419242202},{"$f":"(((2.15*($D$6^0.75))/0.8)*(10*4.184))/1000","v":2.1143050740104972},{"$f":"(((2.15*(E6^0.75))/0.8)*(5*4.184))/1000","v":1.2120585260906696},{"$f":"(((2.15*(F6^0.75))/0.8)*(5*4.184))/1000","v":1.3606100770172076},1.503930071861475,1.6428277690018875,1.7779115574881679]
[null,0,{"$f":"(((2.15*($C$6^0.75))/0.8)*(15*4.184))/1000","v":2.68272651288633},{"$f":"(((2.15*($D$6^0.75))/0.8)*(15*4.184))/1000","v":3.1714576110157453},{"$f":"(((2.15*(E6^0.75))/0.8)*(10*4.184))/1000","v":2.4241170521813391},{"$f":"(((2.15*(F6^0.75))/0.8)*(10*4.184))/1000","v":2.7212201540344152},3.00786014372295,3.2856555380037751,3.5558231149763357]
[null,-5,{"$f":"(((2.15*($C$6^0.75))/0.8)*(20*4.184))/1000","v":3.5769686838484405},{"$f":"(((2.15*($D$6^0.75))/0.8)*(20*4.184))/1000","v":4.2286101480209943},{"$f":"(((2.15*(E6^0.75))/0.8)*(15*4.184))/1000","v":3.6361755782720087},{"$f":"(((2.15*(F6^0.75))/0.8)*(15*4.184))/1000","v":4.0818302310516232},4.5117902155844245,4.9284833070056626,5.3337346724645034]
[null,-10,{"$f":"(((2.15*($C$6^0.75))/0.8)*(25*4.184))/1000","v":4.4712108548105505},{"$f":"(((2.15*($D$6^0.75))/0.8)*(25*4.184))/1000","v":5.2857626850262429},{"$f":"(((2.15*(E6^0.75))/0.8)*(20*4.184))/1000","v":4.8482341043626782},{"$f":"(((2.15*(F6^0.75))/0.8)*(20*4.184))/1000","v":5.4424403080688304},6.0157202874458999,6.5713110760075502,7.1116462299526715]
[null,-15,{"$f":"(((2.15*($C$6^0.75))/0.8)*(30*4.184))/1000","v":5.36545302577266},{"$f":"(((2.15*($D$6^0.75))/0.8)*(30*4.184))/1000","v":6.3429152220314906},{"$f":"(((2.15*(E6^0.75))/0.8)*(25*4.184))/1000","v":6.0602926304533478},{"$f":"(((2.15*(F6^0.75))/0.8)*(25*4.184))/1000","v":6.8030503850860375},7.5196503593073754,8.2141388450094386,8.8895577874408396]
[]
["Assumptions: "]
["Lower critical temperature of calves <60kg is 15C"]
["Lower critical temperature of calves ≥ 60kg is 10C"]
["(based on NRC recommendations)"]

{"sheet":"2. Energy required to grow","index":1,"n_rows":50,"n_cols":10,"rows_kept":50,"cut":false,"hidden":false,"merged":[[11,0,11,3]]}
[]
[]
[]
[]
[]
[]
["Milk Replacer Metabolisable Energy ",null,null,"Concentrate Metabolisable Energy"]
["MJ per kg of milk replacer",{"$f":"'3. Basic Calculator'!F16","v":""},null,"ME of concentrate eaten ",null,{"$f":"'3. Basic Calculator'!F22","v":0},"MJ/kg"]
["MJ per litre of milk replacer",{"$f":"'3. Basic Calculator'!F17","v":""}]
["Total Metabolisable Energy Fed ",{"$f":"'3. Basic Calculator'!F18","v":""}]
[]
["Comparison of Energy Required at Different Growth Rates and Amount of Energy Fed"]
["Body Weight (kg)",40,50,60,70,80,90,100]
["Energy for Maintenance (MJ/d)",{"$f":"0.428*(B13^0.75)","v":6.807517438245954},{"$f":"0.428*(C13^0.75)","v":8.0476906192048805},9.2269295952119972,10.357794707872557,11.448834021196342,12.506208104100811,13.534548385520667]
["Energy received from milk replacer fed",{"$f":"B10","v":""},{"$f":"$B$10","v":""},{"$f":"$B$10","v":""},"","","",""]
["Maintenance and growth at 0.6kg/d (MJ/day)",{"$f":"4.2*((0.1*(B13^0.75))+((0.84*(B13^0.355))*(0.6^1.2)))","v":13.760406434841205},{"$f":"4.2*((0.1*(C13^0.75))+((0.84*(C13^0.355))*(0.6^1.2)))","v":15.561071187703416},17.230706254025179,18.800335186382725,20.290224265720507,21.714494419500415,23.083461871785424]
["Potential energy deficit to grow at 0.6kg/d (MJ/d)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(B16-$B$10)))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(C16-$B$10)))","v":""},"","","","",""]
["Energy required from concentrate (g)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(B17/$F$8)*1000))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(C17/$F$8)*1000))","v":""},"","","","",""]
["Maintenance and growth at 0.8kg/d",{"$f":"4.2*((0.1*(B13^0.75))+((0.84*(B13^0.355))*(0.8^1.2)))","v":16.679534046869058},{"$f":"4.2*((0.1*(C13^0.75))+((0.84*(C13^0.355))*(0.8^1.2)))","v":18.720846019672472},20.601758456939649,22.361004061037566,24.023746391412949,25.607435895560169,27.124768321957163]
["Energy deficit to grow at 0.8kg/d (MJ/d)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001, (B19-B15)))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001, (C19-C15)))","v":""},"","","","",""]
["Energy required from concentrate (g)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(B20/$F$8)*1000))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(C20/$F$8)*1000))","v":""},"","","","",""]
["Maintenance and growth at 1.0kg/d",{"$f":"4.2*((0.1*(B13^0.75))+((0.84*(B13^0.355))*(1^1.2)))","v":19.749801214714459},{"$f":"4.2*((0.1*(C13^0.75))+((0.84*(C13^0.355))*(1^1.2)))","v":22.044220059370417},24.14734887822009,26.106028669203777,27.950573829756703,29.701936715271447,31.375315799922557,null,"Critically important"]
["Energy deficit to grow at 1.0kg/d (MJ/d)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(B22-B15)))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(C22-C15)))","v":""},"","","","","",null,{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"CRITICAL\",$A$6:$A$50,$G23)","v":0}]
["Energy required from concentrate (g)",{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(B23/$F$8)*1000))","v":""},{"$f":"IF($B$8=\"\",\"\",IF($B$8>0.0001,(C23/$F$8)*1000))","v":""},"","","","","",null,{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"CRITICAL\",$A$6:$A$50,$G24)","v":0}]
[null,null,null,{"$f":"IF(B25=\"\",\"\",VLOOKUP(B25,All,9,FALSE))","v":""},{"$f":"IF(B25=\"\",\"\",(C25*(VLOOKUP(B25,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},{"$f":"IF(B25=\"\",\"\",IF((VLOOKUP(B25,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""},"Drytube",{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"\",$A$6:$A$50,$G25)","v":0},null,{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"CRITICAL\",$A$6:$A$50,$G25)","v":0}]
[null,null,null,"",{"$f":"IF(B26=\"\",\"\",(C26*(VLOOKUP(B26,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},"","Footbath",{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"\",$A$6:$A$50,$G26)","v":0},null,{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"CRITICAL\",$A$6:$A$50,$G26)","v":0}]
[null,null,null,"",{"$f":"IF(B27=\"\",\"\",(C27*(VLOOKUP(B27,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},"","Other",{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"\",$A$6:$A$50,$G27)","v":0},null,{"$f":"SUMIFS($E$6:$E$50,$F$6:$F$50,\"CRITICAL\",$A$6:$A$50,$G27)","v":0}]
[null,null,null,"",{"$f":"IF(B28=\"\",\"\",(C28*(VLOOKUP(B28,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B29=\"\",\"\",(C29*(VLOOKUP(B29,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B30=\"\",\"\",(C30*(VLOOKUP(B30,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B31=\"\",\"\",(C31*(VLOOKUP(B31,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B32=\"\",\"\",(C32*(VLOOKUP(B32,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B33=\"\",\"\",(C33*(VLOOKUP(B33,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B34=\"\",\"\",(C34*(VLOOKUP(B34,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B35=\"\",\"\",(C35*(VLOOKUP(B35,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B36=\"\",\"\",(C36*(VLOOKUP(B36,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B37=\"\",\"\",(C37*(VLOOKUP(B37,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B38=\"\",\"\",(C38*(VLOOKUP(B38,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B39=\"\",\"\",(C39*(VLOOKUP(B39,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B40=\"\",\"\",(C40*(VLOOKUP(B40,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B41=\"\",\"\",(C41*(VLOOKUP(B41,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B42=\"\",\"\",(C42*(VLOOKUP(B42,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B43=\"\",\"\",(C43*(VLOOKUP(B43,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B44=\"\",\"\",(C44*(VLOOKUP(B44,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B45=\"\",\"\",(C45*(VLOOKUP(B45,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B46=\"\",\"\",(C46*(VLOOKUP(B46,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B47=\"\",\"\",(C47*(VLOOKUP(B47,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B48=\"\",\"\",(C48*(VLOOKUP(B48,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B49=\"\",\"\",(C49*(VLOOKUP(B49,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]
[null,null,null,"",{"$f":"IF(B50=\"\",\"\",(C50*(VLOOKUP(B50,All,8,FALSE))/('1. Impact of cold stress'!$B$7)))","v":""},""]

{"sheet":"3. Basic Calculator","index":2,"n_rows":63,"n_cols":13,"rows_kept":63,"cut":false,"hidden":false,"merged":[[28,1,28,2],[29,1,29,2],[58,1,58,2],[47,1,47,2],[48,1,48,2],[49,1,49,2],[50,1,50,2],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[55,1,55,2],[56,1,56,2],[57,1,57,2],[59,1,59,2],[60,1,60,2],[61,1,61,2],[62,1,62,2],[36,1,36,2],[37,1,37,2],[38,1,38,2],[39,1,39,2],[40,1,40,2],[41,1,41,2],[42,1,42,2],[43,1,43,2],[44,1,44,2],[45,1,45,2],[46,1,46,2]]}
{"$rows_empty":8}
["Specification of the Milk Replacer Fed"]
["Assumed moisture content",null,null,null,"Amount of Milk Replacer Fed "]
["Crude Protein",null,null,null,"Volume of Milk Replacer ",null,null,"Litres"]
["Crude Fat",null,null,null,"Concentration of Milk Replacer ",null,null,"g/L",{"$f":"IF(G12=\"\",\"\",MAX(0,IF(G12>160,(a))))","v":""}]
["Crude Ash",null,null,null,"Total amount of solids",null,{"$f":"IF(G11=\"\",\"\",IF(G11>0.01, (G12*G11)))","v":""},"grams"]
["Crude Fibre",{"$nulls":9},"Feeding Required to achieve desired growth rates"]
["Calculated Lactose",{"$f":"IF(B11=\"\",\"\",IF(B11>1,(100-B11-B12-B13-B14)))","v":""},null,null,"Metabolisable Energy ",{"$nulls":5},"Total energy required ",{"$f":"IF($B$19=\"\",\"\",IF($B$19<21,($B$22+$B$27),($B$22+$B$28)))","v":""},"MJ/d"]
[{"$nulls":4},"MJ per kg of milk replacer",{"$f":"IF(B11=\"\",\"\",IF(B11>0.001,(((100-B10)/100)*(B11*0.057)+(0.092*B12)+(0.0395*B15))*3.77))","v":""},{"$nulls":4},"Energy from fed concentrate",{"$f":"$F$23","v":""},"MJ/d"]
[{"$nulls":4},"MJ per litre of milk replacer",{"$f":"IF(F16=\"\",\"\",IF(F16>0.001,(F16/1000)*G12))","v":""},{"$nulls":4},"Energy required from milk replacer",{"$f":"IF($L$15=\"\",\"\",IF($L$15>0.01,L15-L16))","v":""},"MJ/d"]
["Calf Information ",null,null,null,"Total Metabolisable Energy Fed ",{"$f":"IF(F17=\"\",\"\",IF(F17>0.001,(F17*G11)))","v":""},{"$nulls":4},"Total amount of solids to be fed ",{"$f":"IF($L$15=\"\",\"\",IF($L$15>0.001,($L$17/$F$16)*1000))","v":""},"grams/d"]
["Age of Calf (days)",{"$nulls":9},"Amount of milk replacer to be fed to achieve desired growth rate",{"$f":"IF($L$15=\"\",\"\",IF($L$15>0.001,($L$18/$G$12)))","v":""},"L/d"]
["Weight of Calf (kg)",null,null,null,"Concentrate Feeding "]
["Desired growth rate (kg/d)",null,null,null,"Amount of concentrate eaten per head per day",null,"g",null,null,null,"Theoretical growth rates achievable on current feeding regime "]
["Required Energy (MJ/d)",{"$f":"4.2*((0.1*(B20^0.75))+((0.84*(B20^0.355))*(B21^1.2)))","v":0},null,null,"ME of concentrate eaten ",null,"MJ/kg",null,null,null,"Energy provided from milk replacer",{"$f":"F18","v":""},"MJ/d"]
[{"$nulls":4},"ME from concentrate fed",{"$f":"IF(F21=\"\",\"\",IF(F21>0.001,((F21/1000)*F22)))","v":""},{"$nulls":4},"Energy provided from concentrates",{"$f":"F23","v":""},"MJ/d"]
[{"$nulls":10},"Impact of cold",{"$f":"IF(L22=\"\",\"\",MAX(0,IF(B19<21,B27,B28)))","v":""},"MJ/d"]
["Environmental Impact ",{"$nulls":9},"Total Energy Provided ",{"$f":"IF(L22=\"\",\"\",(L22+L23)-L24)","v":""},"MJ/d"]
["Environmental Temperature",null,"°C",{"$nulls":7},"Theoretical growth rate",{"$f":"IF(L23=\"\",\"\",(((L25/4.2)-(0.1*(B20^0.75)))/(0.84*(B20^0.355)))^(1/1.2))","v":""},"kg/d"]
["if <3 weeks old",{"$f":"MAX(0,(((2.15*(B20^0.75))/0.8)*((15-B26)*4.184))/1000)","v":0},"MJ/d"]
["if ≥3 weeks old",{"$f":"MAX( 0,(((2.15*(B20^0.75))/0.8)*((10-B26)*4.184))/1000)","v":0},"MJ/d"]
{"$rows_empty":11}
[{"$f":"IF('2. Energy required to grow'!A27=\"\",\"\",'2. Energy required to grow'!A27)","v":""},{"$f":"IF('2. Energy required to grow'!B27=\"\",\"\",'2. Energy required to grow'!B27)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C27=\"\",\"\",'2. Energy required to grow'!C27)","v":""},{"$f":"IF('2. Energy required to grow'!D27=\"\",\"\",'2. Energy required to grow'!D27)","v":""},{"$f":"IF(B40=\"\",\"\",E40*VLOOKUP(B40,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E27=\"\",\"\",'2. Energy required to grow'!E27)","v":""},null,{"$f":"IF(A40=\"\",\"\",IF(A40=\"lactatingtube\",E40/S40/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A40=\"drytube\",\"\",IF(A40=\"Footbath\",G40/S40/'1. Impact of cold stress'!$B$2,IF(B40='Sheet 5'!$A$114,E40/'1. Impact of cold stress'!$B$2,IF(A40=\"other\",H40/S40,IF(U40=\"kg\",H40/S40,\"\")))))))","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"lactatingtube\",E40/T40/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A40=\"drytube\",E40/T40/'1. Impact of cold stress'!$B$2,IF(A40=\"Footbath\",J40,IF(B40='Sheet 5'!$A$114,E40/T40/'1. Impact of cold stress'!$B$2,IF(A40=\"other\",H40/T40,IF(U40=\"kg\",H40/T40,\"\")))))))","v":""},{"$f":"IF(A40=\"\",\"\",IF(A40=\"Footbath\",\"Cow\",IF(B40='Sheet 5'!$A$114,\"Cow\",IF(A40=\"other\",\"PCU\",IF(U40=\"kg\",\"PCU\",IF(U40=\"unit\",\"Cow\",\" \"))))))","v":""},{"$f":"IF(B40=\"\",\"\",IF((VLOOKUP(B40,All,7,FALSE)>0),\"CRITICAL\",\"\"))","v":""}]
[{"$f":"IF('2. Energy required to grow'!A28=\"\",\"\",'2. Energy required to grow'!A28)","v":""},{"$f":"IF('2. Energy required to grow'!B28=\"\",\"\",'2. Energy required to grow'!B28)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C28=\"\",\"\",'2. Energy required to grow'!C28)","v":""},{"$f":"IF('2. Energy required to grow'!D28=\"\",\"\",'2. Energy required to grow'!D28)","v":""},{"$f":"IF(B41=\"\",\"\",E41*VLOOKUP(B41,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E28=\"\",\"\",'2. Energy required to grow'!E28)","v":""},null,{"$f":"IF(A41=\"\",\"\",IF(A41=\"lactatingtube\",E41/S41/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A41=\"drytube\",\"\",IF(A41=\"Footbath\",G41/S41/'1. Impact of cold stress'!$B$2,IF(B41='Sheet 5'!$A$114,E41/'1. Impact of cold stress'!$B$2,IF(A41=\"other\",H41/S41,IF(U41=\"kg\",H41/S41,\"\")))))))","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"lactatingtube\",E41/T41/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A41=\"drytube\",E41/T41/'1. Impact of cold stress'!$B$2,IF(A41=\"Footbath\",J41,IF(B41='Sheet 5'!$A$114,E41/T41/'1. Impact of cold stress'!$B$2,IF(A41=\"other\",H41/T41,IF(U41=\"kg\",H41/T41,\"\")))))))","v":""},{"$f":"IF(A41=\"\",\"\",IF(A41=\"Footbath\",\"Cow\",IF(B41='Sheet 5'!$A$114,\"Cow\",IF(A41=\"other\",\"PCU\",IF(U41=\"kg\",\"PCU\",IF(U41=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A29=\"\",\"\",'2. Energy required to grow'!A29)","v":""},{"$f":"IF('2. Energy required to grow'!B29=\"\",\"\",'2. Energy required to grow'!B29)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C29=\"\",\"\",'2. Energy required to grow'!C29)","v":""},{"$f":"IF('2. Energy required to grow'!D29=\"\",\"\",'2. Energy required to grow'!D29)","v":""},{"$f":"IF(B42=\"\",\"\",E42*VLOOKUP(B42,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E29=\"\",\"\",'2. Energy required to grow'!E29)","v":""},null,{"$f":"IF(A42=\"\",\"\",IF(A42=\"lactatingtube\",E42/S42/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A42=\"drytube\",\"\",IF(A42=\"Footbath\",G42/S42/'1. Impact of cold stress'!$B$2,IF(B42='Sheet 5'!$A$114,E42/'1. Impact of cold stress'!$B$2,IF(A42=\"other\",H42/S42,IF(U42=\"kg\",H42/S42,\"\")))))))","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"lactatingtube\",E42/T42/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A42=\"drytube\",E42/T42/'1. Impact of cold stress'!$B$2,IF(A42=\"Footbath\",J42,IF(B42='Sheet 5'!$A$114,E42/T42/'1. Impact of cold stress'!$B$2,IF(A42=\"other\",H42/T42,IF(U42=\"kg\",H42/T42,\"\")))))))","v":""},{"$f":"IF(A42=\"\",\"\",IF(A42=\"Footbath\",\"Cow\",IF(B42='Sheet 5'!$A$114,\"Cow\",IF(A42=\"other\",\"PCU\",IF(U42=\"kg\",\"PCU\",IF(U42=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A30=\"\",\"\",'2. Energy required to grow'!A30)","v":""},{"$f":"IF('2. Energy required to grow'!B30=\"\",\"\",'2. Energy required to grow'!B30)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C30=\"\",\"\",'2. Energy required to grow'!C30)","v":""},{"$f":"IF('2. Energy required to grow'!D30=\"\",\"\",'2. Energy required to grow'!D30)","v":""},{"$f":"IF(B43=\"\",\"\",E43*VLOOKUP(B43,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E30=\"\",\"\",'2. Energy required to grow'!E30)","v":""},null,{"$f":"IF(A43=\"\",\"\",IF(A43=\"lactatingtube\",E43/S43/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A43=\"drytube\",\"\",IF(A43=\"Footbath\",G43/S43/'1. Impact of cold stress'!$B$2,IF(B43='Sheet 5'!$A$114,E43/'1. Impact of cold stress'!$B$2,IF(A43=\"other\",H43/S43,IF(U43=\"kg\",H43/S43,\"\")))))))","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"lactatingtube\",E43/T43/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A43=\"drytube\",E43/T43/'1. Impact of cold stress'!$B$2,IF(A43=\"Footbath\",J43,IF(B43='Sheet 5'!$A$114,E43/T43/'1. Impact of cold stress'!$B$2,IF(A43=\"other\",H43/T43,IF(U43=\"kg\",H43/T43,\"\")))))))","v":""},{"$f":"IF(A43=\"\",\"\",IF(A43=\"Footbath\",\"Cow\",IF(B43='Sheet 5'!$A$114,\"Cow\",IF(A43=\"other\",\"PCU\",IF(U43=\"kg\",\"PCU\",IF(U43=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A31=\"\",\"\",'2. Energy required to grow'!A31)","v":""},{"$f":"IF('2. Energy required to grow'!B31=\"\",\"\",'2. Energy required to grow'!B31)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C31=\"\",\"\",'2. Energy required to grow'!C31)","v":""},{"$f":"IF('2. Energy required to grow'!D31=\"\",\"\",'2. Energy required to grow'!D31)","v":""},{"$f":"IF(B44=\"\",\"\",E44*VLOOKUP(B44,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E31=\"\",\"\",'2. Energy required to grow'!E31)","v":""},null,{"$f":"IF(A44=\"\",\"\",IF(A44=\"lactatingtube\",E44/S44/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A44=\"drytube\",\"\",IF(A44=\"Footbath\",G44/S44/'1. Impact of cold stress'!$B$2,IF(B44='Sheet 5'!$A$114,E44/'1. Impact of cold stress'!$B$2,IF(A44=\"other\",H44/S44,IF(U44=\"kg\",H44/S44,\"\")))))))","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"lactatingtube\",E44/T44/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A44=\"drytube\",E44/T44/'1. Impact of cold stress'!$B$2,IF(A44=\"Footbath\",J44,IF(B44='Sheet 5'!$A$114,E44/T44/'1. Impact of cold stress'!$B$2,IF(A44=\"other\",H44/T44,IF(U44=\"kg\",H44/T44,\"\")))))))","v":""},{"$f":"IF(A44=\"\",\"\",IF(A44=\"Footbath\",\"Cow\",IF(B44='Sheet 5'!$A$114,\"Cow\",IF(A44=\"other\",\"PCU\",IF(U44=\"kg\",\"PCU\",IF(U44=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A32=\"\",\"\",'2. Energy required to grow'!A32)","v":""},{"$f":"IF('2. Energy required to grow'!B32=\"\",\"\",'2. Energy required to grow'!B32)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C32=\"\",\"\",'2. Energy required to grow'!C32)","v":""},{"$f":"IF('2. Energy required to grow'!D32=\"\",\"\",'2. Energy required to grow'!D32)","v":""},{"$f":"IF(B45=\"\",\"\",E45*VLOOKUP(B45,All,8,FALSE))","v":""},{"$f":"IF('2. Energy required to grow'!E32=\"\",\"\",'2. Energy required to grow'!E32)","v":""},null,{"$f":"IF(A45=\"\",\"\",IF(A45=\"lactatingtube\",E45/S45/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A45=\"drytube\",\"\",IF(A45=\"Footbath\",G45/S45/'1. Impact of cold stress'!$B$2,IF(B45='Sheet 5'!$A$114,E45/'1. Impact of cold stress'!$B$2,IF(A45=\"other\",H45/S45,IF(U45=\"kg\",H45/S45,\"\")))))))","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"lactatingtube\",E45/T45/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A45=\"drytube\",E45/T45/'1. Impact of cold stress'!$B$2,IF(A45=\"Footbath\",J45,IF(B45='Sheet 5'!$A$114,E45/T45/'1. Impact of cold stress'!$B$2,IF(A45=\"other\",H45/T45,IF(U45=\"kg\",H45/T45,\"\")))))))","v":""},{"$f":"IF(A45=\"\",\"\",IF(A45=\"Footbath\",\"Cow\",IF(B45='Sheet 5'!$A$114,\"Cow\",IF(A45=\"other\",\"PCU\",IF(U45=\"kg\",\"PCU\",IF(U45=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A33=\"\",\"\",'2. Energy required to grow'!A33)","v":""},{"$f":"IF('2. Energy required to grow'!B33=\"\",\"\",'2. Energy required to grow'!B33)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C33=\"\",\"\",'2. Energy required to grow'!C33)","v":""},{"$f":"IF('2. Energy required to grow'!D33=\"\",\"\",'2. Energy required to grow'!D33)","v":""},"",{"$f":"IF('2. Energy required to grow'!E33=\"\",\"\",'2. Energy required to grow'!E33)","v":""},null,{"$f":"IF(A46=\"\",\"\",IF(A46=\"lactatingtube\",E46/S46/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A46=\"drytube\",\"\",IF(A46=\"Footbath\",G46/S46/'1. Impact of cold stress'!$B$2,IF(B46='Sheet 5'!$A$114,E46/'1. Impact of cold stress'!$B$2,IF(A46=\"other\",H46/S46,IF(U46=\"kg\",H46/S46,\"\")))))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"lactatingtube\",E46/T46/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A46=\"drytube\",E46/T46/'1. Impact of cold stress'!$B$2,IF(A46=\"Footbath\",J46,IF(B46='Sheet 5'!$A$114,E46/T46/'1. Impact of cold stress'!$B$2,IF(A46=\"other\",H46/T46,IF(U46=\"kg\",H46/T46,\"\")))))))","v":""},{"$f":"IF(A46=\"\",\"\",IF(A46=\"Footbath\",\"Cow\",IF(B46='Sheet 5'!$A$114,\"Cow\",IF(A46=\"other\",\"PCU\",IF(U46=\"kg\",\"PCU\",IF(U46=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A34=\"\",\"\",'2. Energy required to grow'!A34)","v":""},{"$f":"IF('2. Energy required to grow'!B34=\"\",\"\",'2. Energy required to grow'!B34)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C34=\"\",\"\",'2. Energy required to grow'!C34)","v":""},{"$f":"IF('2. Energy required to grow'!D34=\"\",\"\",'2. Energy required to grow'!D34)","v":""},"",{"$f":"IF('2. Energy required to grow'!E34=\"\",\"\",'2. Energy required to grow'!E34)","v":""},null,{"$f":"IF(A47=\"\",\"\",IF(A47=\"lactatingtube\",E47/S47/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A47=\"drytube\",\"\",IF(A47=\"Footbath\",G47/S47/'1. Impact of cold stress'!$B$2,IF(B47='Sheet 5'!$A$114,E47/'1. Impact of cold stress'!$B$2,IF(A47=\"other\",H47/S47,IF(U47=\"kg\",H47/S47,\"\")))))))","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"lactatingtube\",E47/T47/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A47=\"drytube\",E47/T47/'1. Impact of cold stress'!$B$2,IF(A47=\"Footbath\",J47,IF(B47='Sheet 5'!$A$114,E47/T47/'1. Impact of cold stress'!$B$2,IF(A47=\"other\",H47/T47,IF(U47=\"kg\",H47/T47,\"\")))))))","v":""},{"$f":"IF(A47=\"\",\"\",IF(A47=\"Footbath\",\"Cow\",IF(B47='Sheet 5'!$A$114,\"Cow\",IF(A47=\"other\",\"PCU\",IF(U47=\"kg\",\"PCU\",IF(U47=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A35=\"\",\"\",'2. Energy required to grow'!A35)","v":""},{"$f":"IF('2. Energy required to grow'!B35=\"\",\"\",'2. Energy required to grow'!B35)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C35=\"\",\"\",'2. Energy required to grow'!C35)","v":""},{"$f":"IF('2. Energy required to grow'!D35=\"\",\"\",'2. Energy required to grow'!D35)","v":""},"",{"$f":"IF('2. Energy required to grow'!E35=\"\",\"\",'2. Energy required to grow'!E35)","v":""},null,{"$f":"IF(A48=\"\",\"\",IF(A48=\"lactatingtube\",E48/S48/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A48=\"drytube\",\"\",IF(A48=\"Footbath\",G48/S48/'1. Impact of cold stress'!$B$2,IF(B48='Sheet 5'!$A$114,E48/'1. Impact of cold stress'!$B$2,IF(A48=\"other\",H48/S48,IF(U48=\"kg\",H48/S48,\"\")))))))","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"lactatingtube\",E48/T48/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A48=\"drytube\",E48/T48/'1. Impact of cold stress'!$B$2,IF(A48=\"Footbath\",J48,IF(B48='Sheet 5'!$A$114,E48/T48/'1. Impact of cold stress'!$B$2,IF(A48=\"other\",H48/T48,IF(U48=\"kg\",H48/T48,\"\")))))))","v":""},{"$f":"IF(A48=\"\",\"\",IF(A48=\"Footbath\",\"Cow\",IF(B48='Sheet 5'!$A$114,\"Cow\",IF(A48=\"other\",\"PCU\",IF(U48=\"kg\",\"PCU\",IF(U48=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A36=\"\",\"\",'2. Energy required to grow'!A36)","v":""},{"$f":"IF('2. Energy required to grow'!B36=\"\",\"\",'2. Energy required to grow'!B36)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C36=\"\",\"\",'2. Energy required to grow'!C36)","v":""},{"$f":"IF('2. Energy required to grow'!D36=\"\",\"\",'2. Energy required to grow'!D36)","v":""},"",{"$f":"IF('2. Energy required to grow'!E36=\"\",\"\",'2. Energy required to grow'!E36)","v":""},null,{"$f":"IF(A49=\"\",\"\",IF(A49=\"lactatingtube\",E49/S49/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A49=\"drytube\",\"\",IF(A49=\"Footbath\",G49/S49/'1. Impact of cold stress'!$B$2,IF(B49='Sheet 5'!$A$114,E49/'1. Impact of cold stress'!$B$2,IF(A49=\"other\",H49/S49,IF(U49=\"kg\",H49/S49,\"\")))))))","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"lactatingtube\",E49/T49/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A49=\"drytube\",E49/T49/'1. Impact of cold stress'!$B$2,IF(A49=\"Footbath\",J49,IF(B49='Sheet 5'!$A$114,E49/T49/'1. Impact of cold stress'!$B$2,IF(A49=\"other\",H49/T49,IF(U49=\"kg\",H49/T49,\"\")))))))","v":""},{"$f":"IF(A49=\"\",\"\",IF(A49=\"Footbath\",\"Cow\",IF(B49='Sheet 5'!$A$114,\"Cow\",IF(A49=\"other\",\"PCU\",IF(U49=\"kg\",\"PCU\",IF(U49=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A37=\"\",\"\",'2. Energy required to grow'!A37)","v":""},{"$f":"IF('2. Energy required to grow'!B37=\"\",\"\",'2. Energy required to grow'!B37)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C37=\"\",\"\",'2. Energy required to grow'!C37)","v":""},{"$f":"IF('2. Energy required to grow'!D37=\"\",\"\",'2. Energy required to grow'!D37)","v":""},"",{"$f":"IF('2. Energy required to grow'!E37=\"\",\"\",'2. Energy required to grow'!E37)","v":""},null,{"$f":"IF(A50=\"\",\"\",IF(A50=\"lactatingtube\",E50/S50/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A50=\"drytube\",\"\",IF(A50=\"Footbath\",G50/S50/'1. Impact of cold stress'!$B$2,IF(B50='Sheet 5'!$A$114,E50/'1. Impact of cold stress'!$B$2,IF(A50=\"other\",H50/S50,IF(U50=\"kg\",H50/S50,\"\")))))))","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"lactatingtube\",E50/T50/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A50=\"drytube\",E50/T50/'1. Impact of cold stress'!$B$2,IF(A50=\"Footbath\",J50,IF(B50='Sheet 5'!$A$114,E50/T50/'1. Impact of cold stress'!$B$2,IF(A50=\"other\",H50/T50,IF(U50=\"kg\",H50/T50,\"\")))))))","v":""},{"$f":"IF(A50=\"\",\"\",IF(A50=\"Footbath\",\"Cow\",IF(B50='Sheet 5'!$A$114,\"Cow\",IF(A50=\"other\",\"PCU\",IF(U50=\"kg\",\"PCU\",IF(U50=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A38=\"\",\"\",'2. Energy required to grow'!A38)","v":""},{"$f":"IF('2. Energy required to grow'!B38=\"\",\"\",'2. Energy required to grow'!B38)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C38=\"\",\"\",'2. Energy required to grow'!C38)","v":""},{"$f":"IF('2. Energy required to grow'!D38=\"\",\"\",'2. Energy required to grow'!D38)","v":""},"",{"$f":"IF('2. Energy required to grow'!E38=\"\",\"\",'2. Energy required to grow'!E38)","v":""},null,{"$f":"IF(A51=\"\",\"\",IF(A51=\"lactatingtube\",E51/S51/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A51=\"drytube\",\"\",IF(A51=\"Footbath\",G51/S51/'1. Impact of cold stress'!$B$2,IF(B51='Sheet 5'!$A$114,E51/'1. Impact of cold stress'!$B$2,IF(A51=\"other\",H51/S51,IF(U51=\"kg\",H51/S51,\"\")))))))","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"lactatingtube\",E51/T51/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A51=\"drytube\",E51/T51/'1. Impact of cold stress'!$B$2,IF(A51=\"Footbath\",J51,IF(B51='Sheet 5'!$A$114,E51/T51/'1. Impact of cold stress'!$B$2,IF(A51=\"other\",H51/T51,IF(U51=\"kg\",H51/T51,\"\")))))))","v":""},{"$f":"IF(A51=\"\",\"\",IF(A51=\"Footbath\",\"Cow\",IF(B51='Sheet 5'!$A$114,\"Cow\",IF(A51=\"other\",\"PCU\",IF(U51=\"kg\",\"PCU\",IF(U51=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A39=\"\",\"\",'2. Energy required to grow'!A39)","v":""},{"$f":"IF('2. Energy required to grow'!B39=\"\",\"\",'2. Energy required to grow'!B39)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C39=\"\",\"\",'2. Energy required to grow'!C39)","v":""},{"$f":"IF('2. Energy required to grow'!D39=\"\",\"\",'2. Energy required to grow'!D39)","v":""},"",{"$f":"IF('2. Energy required to grow'!E39=\"\",\"\",'2. Energy required to grow'!E39)","v":""},null,{"$f":"IF(A52=\"\",\"\",IF(A52=\"lactatingtube\",E52/S52/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A52=\"drytube\",\"\",IF(A52=\"Footbath\",G52/S52/'1. Impact of cold stress'!$B$2,IF(B52='Sheet 5'!$A$114,E52/'1. Impact of cold stress'!$B$2,IF(A52=\"other\",H52/S52,IF(U52=\"kg\",H52/S52,\"\")))))))","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"lactatingtube\",E52/T52/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A52=\"drytube\",E52/T52/'1. Impact of cold stress'!$B$2,IF(A52=\"Footbath\",J52,IF(B52='Sheet 5'!$A$114,E52/T52/'1. Impact of cold stress'!$B$2,IF(A52=\"other\",H52/T52,IF(U52=\"kg\",H52/T52,\"\")))))))","v":""},{"$f":"IF(A52=\"\",\"\",IF(A52=\"Footbath\",\"Cow\",IF(B52='Sheet 5'!$A$114,\"Cow\",IF(A52=\"other\",\"PCU\",IF(U52=\"kg\",\"PCU\",IF(U52=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A40=\"\",\"\",'2. Energy required to grow'!A40)","v":""},{"$f":"IF('2. Energy required to grow'!B40=\"\",\"\",'2. Energy required to grow'!B40)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C40=\"\",\"\",'2. Energy required to grow'!C40)","v":""},{"$f":"IF('2. Energy required to grow'!D40=\"\",\"\",'2. Energy required to grow'!D40)","v":""},"",{"$f":"IF('2. Energy required to grow'!E40=\"\",\"\",'2. Energy required to grow'!E40)","v":""},null,{"$f":"IF(A53=\"\",\"\",IF(A53=\"lactatingtube\",E53/S53/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A53=\"drytube\",\"\",IF(A53=\"Footbath\",G53/S53/'1. Impact of cold stress'!$B$2,IF(B53='Sheet 5'!$A$114,E53/'1. Impact of cold stress'!$B$2,IF(A53=\"other\",H53/S53,IF(U53=\"kg\",H53/S53,\"\")))))))","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"lactatingtube\",E53/T53/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A53=\"drytube\",E53/T53/'1. Impact of cold stress'!$B$2,IF(A53=\"Footbath\",J53,IF(B53='Sheet 5'!$A$114,E53/T53/'1. Impact of cold stress'!$B$2,IF(A53=\"other\",H53/T53,IF(U53=\"kg\",H53/T53,\"\")))))))","v":""},{"$f":"IF(A53=\"\",\"\",IF(A53=\"Footbath\",\"Cow\",IF(B53='Sheet 5'!$A$114,\"Cow\",IF(A53=\"other\",\"PCU\",IF(U53=\"kg\",\"PCU\",IF(U53=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A41=\"\",\"\",'2. Energy required to grow'!A41)","v":""},{"$f":"IF('2. Energy required to grow'!B41=\"\",\"\",'2. Energy required to grow'!B41)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C41=\"\",\"\",'2. Energy required to grow'!C41)","v":""},{"$f":"IF('2. Energy required to grow'!D41=\"\",\"\",'2. Energy required to grow'!D41)","v":""},"",{"$f":"IF('2. Energy required to grow'!E41=\"\",\"\",'2. Energy required to grow'!E41)","v":""},null,{"$f":"IF(A54=\"\",\"\",IF(A54=\"lactatingtube\",E54/S54/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A54=\"drytube\",\"\",IF(A54=\"Footbath\",G54/S54/'1. Impact of cold stress'!$B$2,IF(B54='Sheet 5'!$A$114,E54/'1. Impact of cold stress'!$B$2,IF(A54=\"other\",H54/S54,IF(U54=\"kg\",H54/S54,\"\")))))))","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"lactatingtube\",E54/T54/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A54=\"drytube\",E54/T54/'1. Impact of cold stress'!$B$2,IF(A54=\"Footbath\",J54,IF(B54='Sheet 5'!$A$114,E54/T54/'1. Impact of cold stress'!$B$2,IF(A54=\"other\",H54/T54,IF(U54=\"kg\",H54/T54,\"\")))))))","v":""},{"$f":"IF(A54=\"\",\"\",IF(A54=\"Footbath\",\"Cow\",IF(B54='Sheet 5'!$A$114,\"Cow\",IF(A54=\"other\",\"PCU\",IF(U54=\"kg\",\"PCU\",IF(U54=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A42=\"\",\"\",'2. Energy required to grow'!A42)","v":""},{"$f":"IF('2. Energy required to grow'!B42=\"\",\"\",'2. Energy required to grow'!B42)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C42=\"\",\"\",'2. Energy required to grow'!C42)","v":""},{"$f":"IF('2. Energy required to grow'!D42=\"\",\"\",'2. Energy required to grow'!D42)","v":""},"",{"$f":"IF('2. Energy required to grow'!E42=\"\",\"\",'2. Energy required to grow'!E42)","v":""},null,{"$f":"IF(A55=\"\",\"\",IF(A55=\"lactatingtube\",E55/S55/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A55=\"drytube\",\"\",IF(A55=\"Footbath\",G55/S55/'1. Impact of cold stress'!$B$2,IF(B55='Sheet 5'!$A$114,E55/'1. Impact of cold stress'!$B$2,IF(A55=\"other\",H55/S55,IF(U55=\"kg\",H55/S55,\"\")))))))","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"lactatingtube\",E55/T55/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A55=\"drytube\",E55/T55/'1. Impact of cold stress'!$B$2,IF(A55=\"Footbath\",J55,IF(B55='Sheet 5'!$A$114,E55/T55/'1. Impact of cold stress'!$B$2,IF(A55=\"other\",H55/T55,IF(U55=\"kg\",H55/T55,\"\")))))))","v":""},{"$f":"IF(A55=\"\",\"\",IF(A55=\"Footbath\",\"Cow\",IF(B55='Sheet 5'!$A$114,\"Cow\",IF(A55=\"other\",\"PCU\",IF(U55=\"kg\",\"PCU\",IF(U55=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A43=\"\",\"\",'2. Energy required to grow'!A43)","v":""},{"$f":"IF('2. Energy required to grow'!B43=\"\",\"\",'2. Energy required to grow'!B43)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C43=\"\",\"\",'2. Energy required to grow'!C43)","v":""},{"$f":"IF('2. Energy required to grow'!D43=\"\",\"\",'2. Energy required to grow'!D43)","v":""},"",{"$f":"IF('2. Energy required to grow'!E43=\"\",\"\",'2. Energy required to grow'!E43)","v":""},null,{"$f":"IF(A56=\"\",\"\",IF(A56=\"lactatingtube\",E56/S56/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A56=\"drytube\",\"\",IF(A56=\"Footbath\",G56/S56/'1. Impact of cold stress'!$B$2,IF(B56='Sheet 5'!$A$114,E56/'1. Impact of cold stress'!$B$2,IF(A56=\"other\",H56/S56,IF(U56=\"kg\",H56/S56,\"\")))))))","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"lactatingtube\",E56/T56/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A56=\"drytube\",E56/T56/'1. Impact of cold stress'!$B$2,IF(A56=\"Footbath\",J56,IF(B56='Sheet 5'!$A$114,E56/T56/'1. Impact of cold stress'!$B$2,IF(A56=\"other\",H56/T56,IF(U56=\"kg\",H56/T56,\"\")))))))","v":""},{"$f":"IF(A56=\"\",\"\",IF(A56=\"Footbath\",\"Cow\",IF(B56='Sheet 5'!$A$114,\"Cow\",IF(A56=\"other\",\"PCU\",IF(U56=\"kg\",\"PCU\",IF(U56=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A44=\"\",\"\",'2. Energy required to grow'!A44)","v":""},{"$f":"IF('2. Energy required to grow'!B44=\"\",\"\",'2. Energy required to grow'!B44)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C44=\"\",\"\",'2. Energy required to grow'!C44)","v":""},{"$f":"IF('2. Energy required to grow'!D44=\"\",\"\",'2. Energy required to grow'!D44)","v":""},"",{"$f":"IF('2. Energy required to grow'!E44=\"\",\"\",'2. Energy required to grow'!E44)","v":""},null,{"$f":"IF(A57=\"\",\"\",IF(A57=\"lactatingtube\",E57/S57/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A57=\"drytube\",\"\",IF(A57=\"Footbath\",G57/S57/'1. Impact of cold stress'!$B$2,IF(B57='Sheet 5'!$A$114,E57/'1. Impact of cold stress'!$B$2,IF(A57=\"other\",H57/S57,IF(U57=\"kg\",H57/S57,\"\")))))))","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"lactatingtube\",E57/T57/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A57=\"drytube\",E57/T57/'1. Impact of cold stress'!$B$2,IF(A57=\"Footbath\",J57,IF(B57='Sheet 5'!$A$114,E57/T57/'1. Impact of cold stress'!$B$2,IF(A57=\"other\",H57/T57,IF(U57=\"kg\",H57/T57,\"\")))))))","v":""},{"$f":"IF(A57=\"\",\"\",IF(A57=\"Footbath\",\"Cow\",IF(B57='Sheet 5'!$A$114,\"Cow\",IF(A57=\"other\",\"PCU\",IF(U57=\"kg\",\"PCU\",IF(U57=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A45=\"\",\"\",'2. Energy required to grow'!A45)","v":""},{"$f":"IF('2. Energy required to grow'!B45=\"\",\"\",'2. Energy required to grow'!B45)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C45=\"\",\"\",'2. Energy required to grow'!C45)","v":""},{"$f":"IF('2. Energy required to grow'!D45=\"\",\"\",'2. Energy required to grow'!D45)","v":""},"",{"$f":"IF('2. Energy required to grow'!E45=\"\",\"\",'2. Energy required to grow'!E45)","v":""},null,{"$f":"IF(A58=\"\",\"\",IF(A58=\"lactatingtube\",E58/S58/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A58=\"drytube\",\"\",IF(A58=\"Footbath\",G58/S58/'1. Impact of cold stress'!$B$2,IF(B58='Sheet 5'!$A$114,E58/'1. Impact of cold stress'!$B$2,IF(A58=\"other\",H58/S58,IF(U58=\"kg\",H58/S58,\"\")))))))","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"lactatingtube\",E58/T58/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A58=\"drytube\",E58/T58/'1. Impact of cold stress'!$B$2,IF(A58=\"Footbath\",J58,IF(B58='Sheet 5'!$A$114,E58/T58/'1. Impact of cold stress'!$B$2,IF(A58=\"other\",H58/T58,IF(U58=\"kg\",H58/T58,\"\")))))))","v":""},{"$f":"IF(A58=\"\",\"\",IF(A58=\"Footbath\",\"Cow\",IF(B58='Sheet 5'!$A$114,\"Cow\",IF(A58=\"other\",\"PCU\",IF(U58=\"kg\",\"PCU\",IF(U58=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A46=\"\",\"\",'2. Energy required to grow'!A46)","v":""},{"$f":"IF('2. Energy required to grow'!B46=\"\",\"\",'2. Energy required to grow'!B46)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C46=\"\",\"\",'2. Energy required to grow'!C46)","v":""},{"$f":"IF('2. Energy required to grow'!D46=\"\",\"\",'2. Energy required to grow'!D46)","v":""},"",{"$f":"IF('2. Energy required to grow'!E46=\"\",\"\",'2. Energy required to grow'!E46)","v":""},null,{"$f":"IF(A59=\"\",\"\",IF(A59=\"lactatingtube\",E59/S59/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A59=\"drytube\",\"\",IF(A59=\"Footbath\",G59/S59/'1. Impact of cold stress'!$B$2,IF(B59='Sheet 5'!$A$114,E59/'1. Impact of cold stress'!$B$2,IF(A59=\"other\",H59/S59,IF(U59=\"kg\",H59/S59,\"\")))))))","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"lactatingtube\",E59/T59/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A59=\"drytube\",E59/T59/'1. Impact of cold stress'!$B$2,IF(A59=\"Footbath\",J59,IF(B59='Sheet 5'!$A$114,E59/T59/'1. Impact of cold stress'!$B$2,IF(A59=\"other\",H59/T59,IF(U59=\"kg\",H59/T59,\"\")))))))","v":""},{"$f":"IF(A59=\"\",\"\",IF(A59=\"Footbath\",\"Cow\",IF(B59='Sheet 5'!$A$114,\"Cow\",IF(A59=\"other\",\"PCU\",IF(U59=\"kg\",\"PCU\",IF(U59=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A47=\"\",\"\",'2. Energy required to grow'!A47)","v":""},{"$f":"IF('2. Energy required to grow'!B47=\"\",\"\",'2. Energy required to grow'!B47)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C47=\"\",\"\",'2. Energy required to grow'!C47)","v":""},{"$f":"IF('2. Energy required to grow'!D47=\"\",\"\",'2. Energy required to grow'!D47)","v":""},"",{"$f":"IF('2. Energy required to grow'!E47=\"\",\"\",'2. Energy required to grow'!E47)","v":""},null,{"$f":"IF(A60=\"\",\"\",IF(A60=\"lactatingtube\",E60/S60/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A60=\"drytube\",\"\",IF(A60=\"Footbath\",G60/S60/'1. Impact of cold stress'!$B$2,IF(B60='Sheet 5'!$A$114,E60/'1. Impact of cold stress'!$B$2,IF(A60=\"other\",H60/S60,IF(U60=\"kg\",H60/S60,\"\")))))))","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"lactatingtube\",E60/T60/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A60=\"drytube\",E60/T60/'1. Impact of cold stress'!$B$2,IF(A60=\"Footbath\",J60,IF(B60='Sheet 5'!$A$114,E60/T60/'1. Impact of cold stress'!$B$2,IF(A60=\"other\",H60/T60,IF(U60=\"kg\",H60/T60,\"\")))))))","v":""},{"$f":"IF(A60=\"\",\"\",IF(A60=\"Footbath\",\"Cow\",IF(B60='Sheet 5'!$A$114,\"Cow\",IF(A60=\"other\",\"PCU\",IF(U60=\"kg\",\"PCU\",IF(U60=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A48=\"\",\"\",'2. Energy required to grow'!A48)","v":""},{"$f":"IF('2. Energy required to grow'!B48=\"\",\"\",'2. Energy required to grow'!B48)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C48=\"\",\"\",'2. Energy required to grow'!C48)","v":""},{"$f":"IF('2. Energy required to grow'!D48=\"\",\"\",'2. Energy required to grow'!D48)","v":""},"",{"$f":"IF('2. Energy required to grow'!E48=\"\",\"\",'2. Energy required to grow'!E48)","v":""},null,{"$f":"IF(A61=\"\",\"\",IF(A61=\"lactatingtube\",E61/S61/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A61=\"drytube\",\"\",IF(A61=\"Footbath\",G61/S61/'1. Impact of cold stress'!$B$2,IF(B61='Sheet 5'!$A$114,E61/'1. Impact of cold stress'!$B$2,IF(A61=\"other\",H61/S61,IF(U61=\"kg\",H61/S61,\"\")))))))","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"lactatingtube\",E61/T61/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A61=\"drytube\",E61/T61/'1. Impact of cold stress'!$B$2,IF(A61=\"Footbath\",J61,IF(B61='Sheet 5'!$A$114,E61/T61/'1. Impact of cold stress'!$B$2,IF(A61=\"other\",H61/T61,IF(U61=\"kg\",H61/T61,\"\")))))))","v":""},{"$f":"IF(A61=\"\",\"\",IF(A61=\"Footbath\",\"Cow\",IF(B61='Sheet 5'!$A$114,\"Cow\",IF(A61=\"other\",\"PCU\",IF(U61=\"kg\",\"PCU\",IF(U61=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A49=\"\",\"\",'2. Energy required to grow'!A49)","v":""},{"$f":"IF('2. Energy required to grow'!B49=\"\",\"\",'2. Energy required to grow'!B49)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C49=\"\",\"\",'2. Energy required to grow'!C49)","v":""},{"$f":"IF('2. Energy required to grow'!D49=\"\",\"\",'2. Energy required to grow'!D49)","v":""},"",{"$f":"IF('2. Energy required to grow'!E49=\"\",\"\",'2. Energy required to grow'!E49)","v":""},null,{"$f":"IF(A62=\"\",\"\",IF(A62=\"lactatingtube\",E62/S62/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A62=\"drytube\",\"\",IF(A62=\"Footbath\",G62/S62/'1. Impact of cold stress'!$B$2,IF(B62='Sheet 5'!$A$114,E62/'1. Impact of cold stress'!$B$2,IF(A62=\"other\",H62/S62,IF(U62=\"kg\",H62/S62,\"\")))))))","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"lactatingtube\",E62/T62/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A62=\"drytube\",E62/T62/'1. Impact of cold stress'!$B$2,IF(A62=\"Footbath\",J62,IF(B62='Sheet 5'!$A$114,E62/T62/'1. Impact of cold stress'!$B$2,IF(A62=\"other\",H62/T62,IF(U62=\"kg\",H62/T62,\"\")))))))","v":""},{"$f":"IF(A62=\"\",\"\",IF(A62=\"Footbath\",\"Cow\",IF(B62='Sheet 5'!$A$114,\"Cow\",IF(A62=\"other\",\"PCU\",IF(U62=\"kg\",\"PCU\",IF(U62=\"unit\",\"Cow\",\" \"))))))","v":""},""]
[{"$f":"IF('2. Energy required to grow'!A50=\"\",\"\",'2. Energy required to grow'!A50)","v":""},{"$f":"IF('2. Energy required to grow'!B50=\"\",\"\",'2. Energy required to grow'!B50)","v":""},null,null,{"$f":"IF('2. Energy required to grow'!C50=\"\",\"\",'2. Energy required to grow'!C50)","v":""},{"$f":"IF('2. Energy required to grow'!D50=\"\",\"\",'2. Energy required to grow'!D50)","v":""},"",{"$f":"IF('2. Energy required to grow'!E50=\"\",\"\",'2. Energy required to grow'!E50)","v":""},null,{"$f":"IF(A63=\"\",\"\",IF(A63=\"lactatingtube\",E63/S63/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A63=\"drytube\",\"\",IF(A63=\"Footbath\",G63/S63/'1. Impact of cold stress'!$B$2,IF(B63='Sheet 5'!$A$114,E63/'1. Impact of cold stress'!$B$2,IF(A63=\"other\",H63/S63,IF(U63=\"kg\",H63/S63,\"\")))))))","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"lactatingtube\",E63/T63/'1. Impact of cold stress'!$B$2,IF('3. Basic Calculator'!A63=\"drytube\",E63/T63/'1. Impact of cold stress'!$B$2,IF(A63=\"Footbath\",J63,IF(B63='Sheet 5'!$A$114,E63/T63/'1. Impact of cold stress'!$B$2,IF(A63=\"other\",H63/T63,IF(U63=\"kg\",H63/T63,\"\")))))))","v":""},{"$f":"IF(A63=\"\",\"\",IF(A63=\"Footbath\",\"Cow\",IF(B63='Sheet 5'!$A$114,\"Cow\",IF(A63=\"other\",\"PCU\",IF(U63=\"kg\",\"PCU\",IF(U63=\"unit\",\"Cow\",\" \"))))))","v":""},""]

{"sheet":"4. Instructions","index":3,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["University of Nottingham Dairy Milk Replacer Calculator"]
["Disclaimer: Please note, use of this calculator is at the users own risk "]
["Instructions"]
["This calculator is designed to provide an estimation of the energy requirements of a pre-weaned dairy heifer and the "]
["amount of energy supplied by the amount of milk replacer fed to the calf "]
["The nutrition specifications of the individual milk replacer will be required, alongside the amount and concentration"]
["of milk replacer fed to the calves. "]
[]
["Enter milk replacer and calf details by clicking: "]
[]
["Please fill in any yellow highlighted squares with the relevant information "]
["The recommended target growth for pre-weaned calves is 0.8kg/day "]
["If the assumed ME of the concentrate feed is unkown, we suggest an assumption of 12ME "]
["If the moisture level of milk replacer is unknown, please assume 5% "]
["The environmental temperature will be required for additional information regarding the potential impact of the "]
["ambient temperature on the energy requirement of the calf "]
["Please beware that it is illegal to feed calves which are less than 28 days old once a day"]
["The current maximum advisable milk replacer concentration is 160g/L and therefore an alert will appear if you feed higher concentrations"]
[]
["For further information regarding the energy requirements of the calves, please click here"]
["The energy requirements of the calf are equal to the calculate energy required for maintenance and growth at different "]
["growth rates, based on bodyweight and at thermoneutral temperatures and humdity"]
["The energy deficit is equal to the difference between the amount of energy required and the amount of energy required "]
["by the calf for maintenance and growth. A lack of energy is a negative and an excess of energy is a positive "]
["The energy required from concentrate equates to the amount of the concentrate that calf would be required to eat to make up "]
["for any potential deficit in energy provided solely by milk replacer. We are not suggesting that the calf is capable of eating and"]
["utilising that amount of concentrate; it is a theoretical amount in order to maintain that level of growth."]
[]
["The impact of cold stress: the theorectical extra energy required by a calf at different temperatures has"]
["been calculated and for more information, please click here"]

{"sheet":"5. Cost Calculator","index":4,"n_rows":1,"n_cols":1,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["r"]

{"sheet":"Sheet 5","index":5,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Yes"]
["No"]